﻿use housing 
declare @noid varchar(30)
set @noid='20091282'
SELECT * FROM [housing].[dbo].[Apply] where   apply_noid=@noid
--delete from [Apply] where apply_noid='20090147'
SELECT *  FROM [housing].[dbo].[Applicant] where app_noid=@noid


SELECT  *  FROM [housing].[dbo].[StreetCheck] 
  